package com.liu.dao;

import com.liu.dto.EmpTjDto;
import com.liu.entity.Employee;

import java.util.List;

public interface EmployeeDao {
    //新增
    int add(Employee employee);
    //查询
    List<Employee> selectAll();
    //删除
    int del(int id);
    //修改
    int update(Employee employee);
    //查询，带条件 动态sql
    List<Employee> selectWhere(String empname);
    //批量删除
    int delBatch(int[] ids);
    //批量新增
    int addBatch(List<Employee> employee);
    //实现图表统计
    List<EmpTjDto> selectTj();
}
